EDA Report

Dataset statistics

Number of variables	17
Number of observations	21045
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 MiB
Average record size in memory	136.0 B

Variable types

Categorical	2
Numeric	15

Alerts

`Date` is highly correlated with `YRMODAHRMI` and 2 other fields	High correlation
`Time` is highly correlated with `Hour`	High correlation
`Altitude` is highly correlated with `Location` and 3 other fields	High correlation
`YRMODAHRMI` is highly correlated with `Date` and 2 other fields	High correlation
`Hour` is highly correlated with `Time`	High correlation
`Humidity` is highly correlated with `Location` and 3 other fields	High correlation
`AmbientTemp` is highly correlated with `Month` and 4 other fields	High correlation
`PolyPwr` is highly correlated with `Humidity` and 1 other fields	High correlation
`Pressure` is highly correlated with `Location` and 5 other fields	High correlation
`Month` is highly correlated with `Date` and 3 other fields	High correlation
`Location` is highly correlated with `Latitude` and 5 other fields	High correlation
`Latitude` is highly correlated with `Location` and 3 other fields	High correlation
`Longitude` is highly correlated with `Location` and 3 other fields	High correlation
`Season` is highly correlated with `Date` and 3 other fields	High correlation
`Cloud.Ceiling` is highly correlated with `Location`	High correlation
`Wind.Speed` has 1787 (8.5%) zeros	Zeros

Reproduction

Analysis started	2022-10-18 15:25:17.856507
Analysis finished	2022-10-18 15:26:11.696929
Duration	53.84 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

Location
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	164.5 KiB

Travis	2746
Peterson	2640
USAFA	2573
Hill Weber	2384
March AFB	2204
Other values (7)	8498

Length

Max length	11
Median length	9
Mean length	7.285863626
Min length	4

Characters and Unicode

Total characters	153331
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Camp Murray
2nd row	Camp Murray
3rd row	Camp Murray
4th row	Camp Murray
5th row	Camp Murray

Common Values

Value	Count	Frequency (%)
Travis	2746	13.0%
Peterson	2640	12.5%
USAFA	2573	12.2%
Hill Weber	2384	11.3%
March AFB	2204	10.5%
JDMT	1779	8.5%
Malmstrom	1517	7.2%
Grissom	1487	7.1%
Camp Murray	1113	5.3%
Kahului	941	4.5%
Other values (2)	1661	7.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
travis	2746	10.3%
peterson	2640	9.9%
usafa	2573	9.6%
hill	2384	8.9%
weber	2384	8.9%
march	2204	8.2%
afb	2204	8.2%
jdmt	1779	6.7%
malmstrom	1517	5.7%
grissom	1487	5.6%
Other values (5)	4828	18.1%

Most occurring characters

Value	Count	Frequency (%)
r	15204	9.9%
e	10048	6.6%
s	9877	6.4%
a	9634	6.3%
A	8130	5.3%
i	7558	4.9%
M	7393	4.8%
l	7226	4.7%
t	5919	3.9%
	5701	3.7%
Other values (26)	66641	43.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	97727	63.7%
Uppercase Letter	49903	32.5%
Space Separator	5701	3.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	15204	15.6%
e	10048	10.3%
s	9877	10.1%
a	9634	9.9%
i	7558	7.7%
l	7226	7.4%
t	5919	6.1%
o	5644	5.8%
m	5634	5.8%
u	3876	4.0%
Other values (8)	17107	17.5%

Uppercase Letter

Value	Count	Frequency (%)
A	8130	16.3%
M	7393	14.8%
F	4777	9.6%
T	4525	9.1%
P	2640	5.3%
S	2573	5.2%
U	2573	5.2%
W	2384	4.8%
H	2384	4.8%
G	2267	4.5%
Other values (7)	10257	20.6%

Space Separator

Value	Count	Frequency (%)
	5701	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	147630	96.3%
Common	5701	3.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	15204	10.3%
e	10048	6.8%
s	9877	6.7%
a	9634	6.5%
A	8130	5.5%
i	7558	5.1%
M	7393	5.0%
l	7226	4.9%
t	5919	4.0%
o	5644	3.8%
Other values (25)	60997	41.3%

Common

Value	Count	Frequency (%)
	5701	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	153331	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	15204	9.9%
e	10048	6.6%
s	9877	6.4%
a	9634	6.3%
A	8130	5.3%
i	7558	4.9%
M	7393	4.8%
l	7226	4.7%
t	5919	3.9%
	5701	3.7%
Other values (26)	66641	43.5%

Date
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	500
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20177196.32

Minimum	20170523
Maximum	20181004
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	20170523
5-th percentile	20170709
Q1	20171110
median	20180317
Q3	20180623
95-th percentile	20180903
Maximum	20181004
Range	10481
Interquartile range (IQR)	9513

Descriptive statistics

Standard deviation	4579.585358
Coefficient of variation (CV)	0.0002269683699
Kurtosis	-1.584172181
Mean	20177196.32
Median Absolute Deviation (MAD)	411
Skewness	-0.6362495955
Sum	4.246290965 × 10¹¹
Variance	20972602.05
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20180406	83	0.4%
20180519	75	0.4%
20180722	75	0.4%
20180609	74	0.4%
20180502	72	0.3%
20180721	72	0.3%
20180602	71	0.3%
20180518	71	0.3%
20180811	69	0.3%
20180816	69	0.3%
Other values (490)	20314	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20170523	4	< 0.1%
20170524	5	< 0.1%
20170525	20	0.1%
20170526	13	0.1%
20170527	18	0.1%
20170528	13	0.1%
20170529	12	0.1%
20170530	14	0.1%
20170531	11	0.1%
20170601	9	< 0.1%

Value	Count	Frequency (%)
20181004	13	0.1%
20181003	11	0.1%
20181002	33	0.2%
20181001	22	0.1%
20180930	24	0.1%
20180929	32	0.2%
20180928	49	0.2%
20180927	47	0.2%
20180926	53	0.3%
20180925	52	0.2%

Time
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1267.483725

Minimum	1000
Maximum	1545
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	1000
5-th percentile	1000
Q1	1100
median	1300
Q3	1400
95-th percentile	1500
Maximum	1545
Range	545
Interquartile range (IQR)	300

Descriptive statistics

Standard deviation	167.6027667
Coefficient of variation (CV)	0.1322326775
Kurtosis	-1.198996556
Mean	1267.483725
Median Absolute Deviation (MAD)	115
Skewness	-0.09593808745
Sum	26674195
Variance	28090.6874
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1500	3223	15.3%
1300	3168	15.1%
1400	3073	14.6%
1200	3034	14.4%
1100	2743	13.0%
1000	2513	11.9%
1030	224	1.1%
1315	223	1.1%
1330	215	1.0%
1445	215	1.0%
Other values (14)	2414	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	2513	11.9%
1015	103	0.5%
1030	224	1.1%
1045	117	0.6%
1100	2743	13.0%
1115	140	0.7%
1130	199	0.9%
1145	169	0.8%
1200	3034	14.4%
1215	195	0.9%

Value	Count	Frequency (%)
1545	146	0.7%
1530	181	0.9%
1515	174	0.8%
1500	3223	15.3%
1445	215	1.0%
1430	207	1.0%
1415	201	1.0%
1400	3073	14.6%
1345	208	1.0%
1330	215	1.0%

Latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.21382324

Minimum	20.89
Maximum	47.52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	20.89
5-th percentile	26.98
Q1	38.16
median	38.95
Q3	41.15
95-th percentile	47.52
Maximum	47.52
Range	26.63
Interquartile range (IQR)	2.99

Descriptive statistics

Standard deviation	6.323760959
Coefficient of variation (CV)	0.1654835979
Kurtosis	0.9838233675
Mean	38.21382324
Median Absolute Deviation (MAD)	2.2
Skewness	-0.9860827074
Sum	804209.91
Variance	39.98995266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
38.16	2746	13.0%
38.82	2640	12.5%
38.95	2573	12.2%
41.15	2384	11.3%
33.9	2204	10.5%
26.98	1779	8.5%
47.52	1517	7.2%
40.67	1487	7.1%
47.11	1113	5.3%
20.89	941	4.5%
Other values (2)	1661	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.89	941	4.5%
26.98	1779	8.5%
33.9	2204	10.5%
38.16	2746	13.0%
38.82	2640	12.5%
38.95	2573	12.2%
40.67	1487	7.1%
41.13	881	4.2%
41.15	2384	11.3%
44.89	780	3.7%

Value	Count	Frequency (%)
47.52	1517	7.2%
47.11	1113	5.3%
44.89	780	3.7%
41.15	2384	11.3%
41.13	881	4.2%
40.67	1487	7.1%
38.95	2573	12.2%
38.82	2640	12.5%
38.16	2746	13.0%
33.9	2204	10.5%

Longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-108.5936778

Minimum	-156.44
Maximum	-80.11
Zeros	0
Zeros (%)	0.0%
Negative	21045
Negative (%)	100.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	-156.44
5-th percentile	-122.57
Q1	-117.26
median	-111.18
Q3	-104.71
95-th percentile	-80.11
Maximum	-80.11
Range	76.33
Interquartile range (IQR)	12.55

Descriptive statistics

Standard deviation	16.3641299
Coefficient of variation (CV)	-0.1506913683
Kurtosis	1.428597136
Mean	-108.5936778
Median Absolute Deviation (MAD)	6.47
Skewness	-0.5501023125
Sum	-2285353.95
Variance	267.7847474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
-121.56	2746	13.0%
-104.71	2640	12.5%
-104.83	2573	12.2%
-111.99	2384	11.3%
-117.26	2204	10.5%
-80.11	1779	8.5%
-111.18	1517	7.2%
-86.15	1487	7.1%
-122.57	1113	5.3%
-156.44	941	4.5%
Other values (2)	1661	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-156.44	941	4.5%
-122.57	1113	5.3%
-121.56	2746	13.0%
-117.26	2204	10.5%
-111.99	2384	11.3%
-111.18	1517	7.2%
-104.83	2573	12.2%
-104.71	2640	12.5%
-95.75	881	4.2%
-93.2	780	3.7%

Value	Count	Frequency (%)
-80.11	1779	8.5%
-86.15	1487	7.1%
-93.2	780	3.7%
-95.75	881	4.2%
-104.71	2640	12.5%
-104.83	2573	12.2%
-111.18	1517	7.2%
-111.99	2384	11.3%
-117.26	2204	10.5%
-121.56	2746	13.0%

Altitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	798.8436683

Minimum	1
Maximum	1947
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	458
Q3	1370
95-th percentile	1947
Maximum	1947
Range	1946
Interquartile range (IQR)	1368

Descriptive statistics

Standard deviation	770.6817943
Coefficient of variation (CV)	0.9647467018
Kurtosis	-1.504816817
Mean	798.8436683
Median Absolute Deviation (MAD)	457
Skewness	0.4117204744
Sum	16811665
Variance	593950.428
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	2746	13.0%
2	2720	12.9%
1879	2640	12.5%
1947	2573	12.2%
1370	2384	11.3%
458	2204	10.5%
1043	1517	7.2%
239	1487	7.1%
84	1113	5.3%
380	881	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2746	13.0%
2	2720	12.9%
84	1113	5.3%
239	1487	7.1%
246	780	3.7%
380	881	4.2%
458	2204	10.5%
1043	1517	7.2%
1370	2384	11.3%
1879	2640	12.5%

Value	Count	Frequency (%)
1947	2573	12.2%
1879	2640	12.5%
1370	2384	11.3%
1043	1517	7.2%
458	2204	10.5%
380	881	4.2%
246	780	3.7%
239	1487	7.1%
84	1113	5.3%
2	2720	12.9%

YRMODAHRMI
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	18
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.01771807 × 10¹¹

Minimum	2.01705 × 10¹¹
Maximum	2.0181 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	2.01705 × 10¹¹
5-th percentile	2.01707 × 10¹¹
Q1	2.01711 × 10¹¹
median	2.01803 × 10¹¹
Q3	2.01806 × 10¹¹
95-th percentile	2.01809 × 10¹¹
Maximum	2.0181 × 10¹¹
Range	105000000
Interquartile range (IQR)	95000000

Descriptive statistics

Standard deviation	45798457.77
Coefficient of variation (CV)	0.0002269814522
Kurtosis	-1.58412901
Mean	2.01771807 × 10¹¹
Median Absolute Deviation (MAD)	4000000
Skewness	-0.6362630047
Sum	4.246287679 × 10¹⁵
Variance	2.097498734 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
2.01807 × 10¹¹	1818	8.6%
2.01805 × 10¹¹	1815	8.6%
2.01808 × 10¹¹	1805	8.6%
2.01806 × 10¹¹	1707	8.1%
2.01804 × 10¹¹	1540	7.3%
2.01801 × 10¹¹	1382	6.6%
2.01803 × 10¹¹	1343	6.4%
2.01711 × 10¹¹	1260	6.0%
2.01809 × 10¹¹	1138	5.4%
2.01712 × 10¹¹	1137	5.4%
Other values (8)	6100	29.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.01705 × 10¹¹	110	0.5%
2.01706 × 10¹¹	637	3.0%
2.01707 × 10¹¹	1111	5.3%
2.01708 × 10¹¹	1130	5.4%
2.01709 × 10¹¹	1106	5.3%
2.0171 × 10¹¹	824	3.9%
2.01711 × 10¹¹	1260	6.0%
2.01712 × 10¹¹	1137	5.4%
2.01801 × 10¹¹	1382	6.6%
2.01802 × 10¹¹	1103	5.2%

Value	Count	Frequency (%)
2.0181 × 10¹¹	79	0.4%
2.01809 × 10¹¹	1138	5.4%
2.01808 × 10¹¹	1805	8.6%
2.01807 × 10¹¹	1818	8.6%
2.01806 × 10¹¹	1707	8.1%
2.01805 × 10¹¹	1815	8.6%
2.01804 × 10¹¹	1540	7.3%
2.01803 × 10¹¹	1343	6.4%
2.01802 × 10¹¹	1103	5.2%
2.01801 × 10¹¹	1382	6.6%

Month
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.565882632

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.983958121
Coefficient of variation (CV)	0.4544641274
Kurtosis	-0.7240518019
Mean	6.565882632
Median Absolute Deviation (MAD)	2
Skewness	-0.121414139
Sum	138179
Variance	8.90400607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
8	2935	13.9%
7	2929	13.9%
6	2344	11.1%
9	2244	10.7%
5	1925	9.1%
4	1540	7.3%
1	1382	6.6%
3	1343	6.4%
11	1260	6.0%
12	1137	5.4%
Other values (2)	2006	9.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1382	6.6%
2	1103	5.2%
3	1343	6.4%
4	1540	7.3%
5	1925	9.1%
6	2344	11.1%
7	2929	13.9%
8	2935	13.9%
9	2244	10.7%
10	903	4.3%

Value	Count	Frequency (%)
12	1137	5.4%
11	1260	6.0%
10	903	4.3%
9	2244	10.7%
8	2935	13.9%
7	2929	13.9%
6	2344	11.1%
5	1925	9.1%
4	1540	7.3%
3	1343	6.4%

Hour
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.62784509

Minimum	10
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	10
5-th percentile	10
Q1	11
median	13
Q3	14
95-th percentile	15
Maximum	15
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.67295201
Coefficient of variation (CV)	0.1324811951
Kurtosis	-1.207316578
Mean	12.62784509
Median Absolute Deviation (MAD)	1
Skewness	-0.09257268679
Sum	265753
Variance	2.798768427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
13	3814	18.1%
15	3724	17.7%
14	3696	17.6%
12	3603	17.1%
11	3251	15.4%
10	2957	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	2957	14.1%
11	3251	15.4%
12	3603	17.1%
13	3814	18.1%
14	3696	17.6%
15	3724	17.7%

Value	Count	Frequency (%)
15	3724	17.7%
14	3696	17.6%
13	3814	18.1%
12	3603	17.1%
11	3251	15.4%
10	2957	14.1%

Season
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	164.5 KiB

Summer	8208
Spring	4808
Fall	4407
Winter	3622

Length

Max length	6
Median length	6
Mean length	5.581183179
Min length	4

Characters and Unicode

Total characters	117456
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Winter
2nd row	Winter
3rd row	Winter
4th row	Winter
5th row	Winter

Common Values

Value	Count	Frequency (%)
Summer	8208	39.0%
Spring	4808	22.8%
Fall	4407	20.9%
Winter	3622	17.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
summer	8208	39.0%
spring	4808	22.8%
fall	4407	20.9%
winter	3622	17.2%

Most occurring characters

Value	Count	Frequency (%)
r	16638	14.2%
m	16416	14.0%
S	13016	11.1%
e	11830	10.1%
l	8814	7.5%
i	8430	7.2%
n	8430	7.2%
u	8208	7.0%
p	4808	4.1%
g	4808	4.1%
Other values (4)	16058	13.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	96411	82.1%
Uppercase Letter	21045	17.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	16638	17.3%
m	16416	17.0%
e	11830	12.3%
l	8814	9.1%
i	8430	8.7%
n	8430	8.7%
u	8208	8.5%
p	4808	5.0%
g	4808	5.0%
a	4407	4.6%

Uppercase Letter

Value	Count	Frequency (%)
S	13016	61.8%
F	4407	20.9%
W	3622	17.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	117456	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	16638	14.2%
m	16416	14.0%
S	13016	11.1%
e	11830	10.1%
l	8814	7.5%
i	8430	7.2%
n	8430	7.2%
u	8208	7.0%
p	4808	4.1%
g	4808	4.1%
Other values (4)	16058	13.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	16638	14.2%
m	16416	14.0%
S	13016	11.1%
e	11830	10.1%
l	8814	7.5%
i	8430	7.2%
n	8430	7.2%
u	8208	7.0%
p	4808	4.1%
g	4808	4.1%
Other values (4)	16058	13.7%

Humidity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10356
Distinct (%)	49.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.12194073

Minimum	0
Maximum	99.98779
Zeros	52
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	0
5-th percentile	6.26465
Q1	17.5293
median	33.12378
Q3	52.59399
95-th percentile	84.254148
Maximum	99.98779
Range	99.98779
Interquartile range (IQR)	35.06469

Descriptive statistics

Standard deviation	23.82301129
Coefficient of variation (CV)	0.641750157
Kurtosis	-0.2626667736
Mean	37.12194073
Median Absolute Deviation (MAD)	17.08374
Skewness	0.6652577812
Sum	781231.2427
Variance	567.535867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99.98779	200	1.0%
0	52	0.2%
11.03516	11	0.1%
9.29565	11	0.1%
17.54761	9	< 0.1%
29.20532	8	< 0.1%
21.30737	8	< 0.1%
16.79688	8	< 0.1%
37.77466	8	< 0.1%
15.41748	8	< 0.1%
Other values (10346)	20722	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	52	0.2%
0.0061	1	< 0.1%
0.02441	1	< 0.1%
0.03052	1	< 0.1%
0.04883	2	< 0.1%
0.07324	1	< 0.1%
0.16479	1	< 0.1%
0.1709	1	< 0.1%
0.19531	1	< 0.1%
0.23193	1	< 0.1%

Value	Count	Frequency (%)
99.98779	200	1.0%
99.95728	1	< 0.1%
99.93896	1	< 0.1%
99.93286	1	< 0.1%
99.92676	1	< 0.1%
99.89014	1	< 0.1%
99.85962	1	< 0.1%
99.84131	1	< 0.1%
99.79858	1	< 0.1%
99.73755	3	< 0.1%

AmbientTemp
Real number (ℝ)

HIGH CORRELATION

Distinct	5259
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.28511702

Minimum	-19.98177
Maximum	65.73837
Zeros	0
Zeros (%)	0.0%
Negative	264
Negative (%)	1.3%
Memory size	164.5 KiB

Quantile statistics

Minimum	-19.98177
5-th percentile	7.0961
Q1	21.91528
median	30.28915
Q3	37.47467
95-th percentile	49.00322
Maximum	65.73837
Range	85.72014
Interquartile range (IQR)	15.55939

Descriptive statistics

Standard deviation	12.36682047
Coefficient of variation (CV)	0.4222902871
Kurtosis	0.1613385729
Mean	29.28511702
Median Absolute Deviation (MAD)	7.75703
Skewness	-0.3264691886
Sum	616305.2876
Variance	152.9382486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.31181	19	0.1%
39.30756	19	0.1%
28.47137	18	0.1%
26.47987	17	0.1%
37.44698	17	0.1%
37.47719	17	0.1%
36.20827	17	0.1%
31.03943	17	0.1%
34.9041	17	0.1%
29.05548	17	0.1%
Other values (5249)	20870	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-19.98177	1	< 0.1%
-18.67256	1	< 0.1%
-18.67004	1	< 0.1%
-18.64487	1	< 0.1%
-18.58948	1	< 0.1%
-18.0658	1	< 0.1%
-17.99782	1	< 0.1%
-17.30797	1	< 0.1%
-16.75911	1	< 0.1%
-16.07681	1	< 0.1%

Value	Count	Frequency (%)
65.73837	1	< 0.1%
64.50218	1	< 0.1%
64.43672	1	< 0.1%
63.90549	1	< 0.1%
63.86269	1	< 0.1%
63.21564	1	< 0.1%
62.58369	1	< 0.1%
62.48299	1	< 0.1%
61.987	1	< 0.1%
61.98196	1	< 0.1%

PolyPwr
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	18804
Distinct (%)	89.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.97858273

Minimum	0.25733
Maximum	34.28502
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	0.25733
5-th percentile	2.14695
Q1	6.40457
median	13.7987
Q3	18.86365
95-th percentile	23.634938
Maximum	34.28502
Range	34.02769
Interquartile range (IQR)	12.45908

Descriptive statistics

Standard deviation	7.12325543
Coefficient of variation (CV)	0.548846941
Kurtosis	-1.082213033
Mean	12.97858273
Median Absolute Deviation (MAD)	5.94676
Skewness	-0.03534716445
Sum	273134.2735
Variance	50.74076792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.16637	18	0.1%
2.77937	15	0.1%
2.88492	15	0.1%
0.80937	14	0.1%
4.3633	12	0.1%
3.20155	12	0.1%
3.62456	12	0.1%
2.95528	12	0.1%
2.74419	12	0.1%
3.02564	10	< 0.1%
Other values (18794)	20913	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.25733	1	< 0.1%
0.27026	1	< 0.1%
0.27234	1	< 0.1%
0.28152	2	< 0.1%
0.28512	1	< 0.1%
0.28701	1	< 0.1%
0.3013	1	< 0.1%
0.30784	1	< 0.1%
0.3099	1	< 0.1%
0.31405	1	< 0.1%

Value	Count	Frequency (%)
34.28502	1	< 0.1%
34.26963	1	< 0.1%
33.58673	1	< 0.1%
33.57887	1	< 0.1%
33.24192	1	< 0.1%
33.14919	1	< 0.1%
32.08935	1	< 0.1%
32.07423	1	< 0.1%
31.98307	1	< 0.1%
31.76329	1	< 0.1%

Wind.Speed
Real number (ℝ_≥0)

ZEROS

Distinct	40
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.31831789

Minimum	0
Maximum	49
Zeros	1787
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	9
Q3	14
95-th percentile	22
Maximum	49
Range	49
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	6.385029998
Coefficient of variation (CV)	0.6188053195
Kurtosis	0.5282312904
Mean	10.31831789
Median Absolute Deviation (MAD)	4
Skewness	0.6270857455
Sum	217149
Variance	40.76860808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
0	1787	8.5%
8	1660	7.9%
7	1633	7.8%
9	1557	7.4%
6	1544	7.3%
10	1467	7.0%
5	1408	6.7%
11	1302	6.2%
3	1204	5.7%
13	1181	5.6%
Other values (30)	6302	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1787	8.5%
1	1	< 0.1%
2	12	0.1%
3	1204	5.7%
5	1408	6.7%
6	1544	7.3%
7	1633	7.8%
8	1660	7.9%
9	1557	7.4%
10	1467	7.0%

Value	Count	Frequency (%)
49	2	< 0.1%
47	1	< 0.1%
43	1	< 0.1%
41	1	< 0.1%
40	4	< 0.1%
39	2	< 0.1%
38	3	< 0.1%
37	5	< 0.1%
36	4	< 0.1%
34	11	0.1%

Visibility
Real number (ℝ_≥0)

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.700071276

Minimum	0
Maximum	10
Zeros	68
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.351948651
Coefficient of variation (CV)	0.1393751254
Kurtosis	27.27661223
Mean	9.700071276
Median Absolute Deviation (MAD)	0
Skewness	-5.144762537
Sum	204138
Variance	1.827765154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
10	19668	93.5%
9.1	231	1.1%
7	193	0.9%
8	177	0.8%
6	146	0.7%
5	123	0.6%
4	111	0.5%
3	95	0.5%
0	68	0.3%
2	62	0.3%
Other values (15)	171	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	68	0.3%
0.1	8	< 0.1%
0.3	13	0.1%
0.4	5	< 0.1%
0.5	12	0.1%
0.6	2	< 0.1%
0.8	13	0.1%
0.9	8	< 0.1%
1	36	0.2%
1.3	11	0.1%

Value	Count	Frequency (%)
10	19668	93.5%
9.1	231	1.1%
8.8	2	< 0.1%
8	177	0.8%
7	193	0.9%
6.9	1	< 0.1%
6.2	5	< 0.1%
6	146	0.7%
5	123	0.6%
4	111	0.5%

Pressure
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	934
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	925.944747

Minimum	781.7
Maximum	1029.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	781.7
5-th percentile	799.5
Q1	845.5
median	961.1
Q3	1008.9
95-th percentile	1019.2
Maximum	1029.5
Range	247.8
Interquartile range (IQR)	163.4

Descriptive statistics

Standard deviation	85.21565875
Coefficient of variation (CV)	0.09203104077
Kurtosis	-1.558003544
Mean	925.944747
Median Absolute Deviation (MAD)	56.8
Skewness	-0.3588775394
Sum	19486507.2
Variance	7261.708497
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1010.9	130	0.6%
1009.6	128	0.6%
1010.6	123	0.6%
959.8	122	0.6%
1009.9	120	0.6%
959.2	117	0.6%
1009.2	113	0.5%
1008.9	110	0.5%
1018.2	107	0.5%
1011.6	107	0.5%
Other values (924)	19868	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
781.7	1	< 0.1%
782.3	6	< 0.1%
782.5	1	< 0.1%
782.8	4	< 0.1%
783.1	1	< 0.1%
783.4	3	< 0.1%
783.6	3	< 0.1%
783.9	8	< 0.1%
784.2	3	< 0.1%
784.5	1	< 0.1%

Value	Count	Frequency (%)
1029.5	2	< 0.1%
1029.4	1	< 0.1%
1029.2	2	< 0.1%
1029.1	3	< 0.1%
1028.8	2	< 0.1%
1028.7	4	< 0.1%
1028.5	1	< 0.1%
1028.4	7	< 0.1%
1028.2	1	< 0.1%
1028.1	3	< 0.1%

Cloud.Ceiling
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	79
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	515.9667855

Minimum	0
Maximum	722
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	164.5 KiB

Quantile statistics

Minimum	0
5-th percentile	16
Q1	140
median	722
Q3	722
95-th percentile	722
Maximum	722
Range	722
Interquartile range (IQR)	582

Descriptive statistics

Standard deviation	301.9033793
Coefficient of variation (CV)	0.5851217323
Kurtosis	-1.252785313
Mean	515.9667855
Median Absolute Deviation (MAD)	0
Skewness	-0.8224788989
Sum	10858521
Variance	91145.65044
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
722	14256	67.7%
250	588	2.8%
200	226	1.1%
60	215	1.0%
50	192	0.9%
55	186	0.9%
100	168	0.8%
110	150	0.7%
150	137	0.7%
70	132	0.6%
Other values (69)	4795	22.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	10	< 0.1%
2	73	0.3%
3	43	0.2%
4	49	0.2%
5	57	0.3%
6	61	0.3%
7	81	0.4%
8	97	0.5%
9	72	0.3%

Value	Count	Frequency (%)
722	14256	67.7%
300	35	0.2%
250	588	2.8%
240	73	0.3%
230	53	0.3%
220	42	0.2%
210	42	0.2%
200	226	1.1%
190	61	0.3%
180	83	0.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Location	Date	Time	Latitude	Longitude	Altitude	YRMODAHRMI	Month	Hour	Season	Humidity	AmbientTemp	PolyPwr	Wind.Speed	Visibility	Pressure	Cloud.Ceiling
0	Camp Murray	20171203	1145	47.11	-122.57	84	2.017120e+11	12	11	Winter	81.71997	12.86919	2.42769	5	10.0	1010.6	722
1	Camp Murray	20171203	1315	47.11	-122.57	84	2.017120e+11	12	13	Winter	96.64917	9.66415	2.46273	0	10.0	1011.3	23
2	Camp Murray	20171203	1330	47.11	-122.57	84	2.017120e+11	12	13	Winter	93.61572	15.44983	4.46836	5	10.0	1011.6	32
3	Camp Murray	20171204	1230	47.11	-122.57	84	2.017120e+11	12	12	Winter	77.21558	10.36659	1.65364	5	2.0	1024.4	6
4	Camp Murray	20171204	1415	47.11	-122.57	84	2.017120e+11	12	14	Winter	54.80347	16.85471	6.57939	3	3.0	1023.7	9
5	Camp Murray	20171204	1430	47.11	-122.57	84	2.017120e+11	12	14	Winter	47.10083	18.12363	2.92027	0	5.0	1023.7	722
6	Camp Murray	20171205	1115	47.11	-122.57	84	2.017120e+11	12	11	Winter	43.55469	19.41269	3.41284	0	4.0	1025.7	722
7	Camp Murray	20171205	1200	47.11	-122.57	84	2.017120e+11	12	12	Winter	30.56641	23.90930	4.82020	5	7.0	1026.0	722
8	Camp Murray	20171205	1300	47.11	-122.57	84	2.017120e+11	12	13	Winter	17.90771	32.32346	5.98127	5	10.0	1025.7	722
9	Camp Murray	20171205	1400	47.11	-122.57	84	2.017120e+11	12	14	Winter	14.40430	35.41267	4.96121	6	10.0	1025.4	722

Last rows

	Location	Date	Time	Latitude	Longitude	Altitude	YRMODAHRMI	Month	Hour	Season	Humidity	AmbientTemp	PolyPwr	Wind.Speed	Visibility	Pressure	Cloud.Ceiling
21035	USAFA	20180928	1330	38.95	-104.83	1947	2.018090e+11	9	13	Fall	15.83252	35.46806	16.15487	15	10.0	803.1	722
21036	USAFA	20180928	1400	38.95	-104.83	1947	2.018090e+11	9	14	Fall	13.26294	40.61424	15.75055	16	10.0	802.8	722
21037	USAFA	20180928	1445	38.95	-104.83	1947	2.018090e+11	9	14	Fall	11.03516	44.46884	14.00045	14	10.0	802.3	722
21038	USAFA	20180928	1500	38.95	-104.83	1947	2.018090e+11	9	15	Fall	11.73096	43.85201	12.91739	16	10.0	802.3	722
21039	USAFA	20180928	1515	38.95	-104.83	1947	2.018090e+11	9	15	Fall	11.46851	43.81424	11.52955	14	10.0	802.3	722
21040	USAFA	20180928	1530	38.95	-104.83	1947	2.018090e+11	9	15	Fall	11.66992	43.22510	9.79611	14	10.0	802.3	722
21041	USAFA	20180929	1300	38.95	-104.83	1947	2.018090e+11	9	13	Fall	18.22510	28.98247	10.88992	13	10.0	799.2	722
21042	USAFA	20180929	1400	38.95	-104.83	1947	2.018090e+11	9	14	Fall	15.52124	33.49167	8.24479	10	10.0	798.4	722
21043	USAFA	20180929	1500	38.95	-104.83	1947	2.018090e+11	9	15	Fall	6.63452	51.62163	12.47328	10	10.0	797.8	722
21044	USAFA	20181001	1400	38.95	-104.83	1947	2.018100e+11	10	14	Fall	22.58301	32.83958	6.39732	15	10.0	801.2	110

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows